Pandas Profiling Report

Dataset statistics

Number of variables	33
Number of observations	10324
Missing cells	2383
Missing cells (%)	0.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.5 MiB
Average record size in memory	257.0 B

Variable types

Numeric	7
Categorical	25
Boolean	1

Alerts

`project code` has a high cardinality: 142 distinct values	High cardinality
`pq #` has a high cardinality: 1237 distinct values	High cardinality
`po / so #` has a high cardinality: 6233 distinct values	High cardinality
`asn/dn #` has a high cardinality: 7030 distinct values	High cardinality
`pq first sent to client date` has a high cardinality: 765 distinct values	High cardinality
`po sent to vendor date` has a high cardinality: 897 distinct values	High cardinality
`scheduled delivery date` has a high cardinality: 2006 distinct values	High cardinality
`delivered to client date` has a high cardinality: 2093 distinct values	High cardinality
`delivery recorded date` has a high cardinality: 2042 distinct values	High cardinality
`vendor` has a high cardinality: 73 distinct values	High cardinality
`item description` has a high cardinality: 184 distinct values	High cardinality
`molecule/test type` has a high cardinality: 86 distinct values	High cardinality
`dosage` has a high cardinality: 54 distinct values	High cardinality
`manufacturing site` has a high cardinality: 88 distinct values	High cardinality
`weight (kilograms)` has a high cardinality: 4688 distinct values	High cardinality
`freight cost (usd)` has a high cardinality: 6733 distinct values	High cardinality
`line item quantity` is highly correlated with `line item value` and 1 other fields	High correlation
`line item value` is highly correlated with `line item quantity` and 1 other fields	High correlation
`pack price` is highly correlated with `unit price`	High correlation
`unit price` is highly correlated with `pack price`	High correlation
`line item insurance (usd)` is highly correlated with `line item quantity` and 1 other fields	High correlation
`line item quantity` is highly correlated with `line item value` and 1 other fields	High correlation
`line item value` is highly correlated with `line item quantity` and 1 other fields	High correlation
`line item insurance (usd)` is highly correlated with `line item quantity` and 1 other fields	High correlation
`line item quantity` is highly correlated with `line item value` and 1 other fields	High correlation
`line item value` is highly correlated with `line item quantity` and 1 other fields	High correlation
`pack price` is highly correlated with `unit price`	High correlation
`unit price` is highly correlated with `pack price`	High correlation
`line item insurance (usd)` is highly correlated with `line item quantity` and 1 other fields	High correlation
`vendor` is highly correlated with `manufacturing site` and 6 other fields	High correlation
`shipment mode` is highly correlated with `country`	High correlation
`dosage form` is highly correlated with `manufacturing site` and 5 other fields	High correlation
`manufacturing site` is highly correlated with `vendor` and 6 other fields	High correlation
`vendor inco term` is highly correlated with `vendor` and 1 other fields	High correlation
`sub classification` is highly correlated with `vendor` and 6 other fields	High correlation
`brand` is highly correlated with `vendor` and 7 other fields	High correlation
`fulfill via` is highly correlated with `vendor` and 5 other fields	High correlation
`molecule/test type` is highly correlated with `vendor` and 7 other fields	High correlation
`dosage` is highly correlated with `dosage form` and 4 other fields	High correlation
`country` is highly correlated with `shipment mode` and 1 other fields	High correlation
`product group` is highly correlated with `vendor` and 6 other fields	High correlation
`id` is highly correlated with `country` and 6 other fields	High correlation
`country` is highly correlated with `id` and 11 other fields	High correlation
`managed by` is highly correlated with `vendor` and 1 other fields	High correlation
`fulfill via` is highly correlated with `id` and 10 other fields	High correlation
`vendor inco term` is highly correlated with `id` and 9 other fields	High correlation
`shipment mode` is highly correlated with `country` and 4 other fields	High correlation
`product group` is highly correlated with `country` and 8 other fields	High correlation
`sub classification` is highly correlated with `country` and 9 other fields	High correlation
`vendor` is highly correlated with `id` and 15 other fields	High correlation
`molecule/test type` is highly correlated with `id` and 14 other fields	High correlation
`brand` is highly correlated with `id` and 13 other fields	High correlation
`dosage` is highly correlated with `country` and 10 other fields	High correlation
`dosage form` is highly correlated with `country` and 10 other fields	High correlation
`unit of measure (per pack)` is highly correlated with `product group` and 7 other fields	High correlation
`line item quantity` is highly correlated with `line item value` and 1 other fields	High correlation
`line item value` is highly correlated with `line item quantity` and 1 other fields	High correlation
`pack price` is highly correlated with `vendor` and 3 other fields	High correlation
`unit price` is highly correlated with `vendor` and 3 other fields	High correlation
`manufacturing site` is highly correlated with `id` and 14 other fields	High correlation
`line item insurance (usd)` is highly correlated with `line item quantity` and 1 other fields	High correlation
`shipment mode` has 360 (3.5%) missing values	Missing
`dosage` has 1736 (16.8%) missing values	Missing
`line item insurance (usd)` has 287 (2.8%) missing values	Missing
`unit price` is highly skewed (γ1 = 40.58484939)	Skewed
`id` has unique values	Unique

Reproduction

Analysis started	2022-09-29 15:27:43.542807
Analysis finished	2022-09-29 15:28:04.486913
Duration	20.94 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	10324
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51098.96823

Minimum	1
Maximum	86823
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	5151.2
Q1	12795.75
median	57540.5
Q3	83648.25
95-th percentile	86167.85
Maximum	86823
Range	86822
Interquartile range (IQR)	70852.5

Descriptive statistics

Standard deviation	31944.3325
Coefficient of variation (CV)	0.6251463308
Kurtosis	-1.639837204
Mean	51098.96823
Median Absolute Deviation (MAD)	27404
Skewness	-0.2303667089
Sum	527545748
Variance	1020440379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
82565	1	< 0.1%
82594	1	< 0.1%
82595	1	< 0.1%
82596	1	< 0.1%
82597	1	< 0.1%
82599	1	< 0.1%
82600	1	< 0.1%
82601	1	< 0.1%
82602	1	< 0.1%
Other values (10314)	10314	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
23	1	< 0.1%
44	1	< 0.1%
45	1	< 0.1%
46	1	< 0.1%
47	1	< 0.1%

Value	Count	Frequency (%)
86823	1	< 0.1%
86822	1	< 0.1%
86821	1	< 0.1%
86819	1	< 0.1%
86818	1	< 0.1%
86817	1	< 0.1%
86816	1	< 0.1%
86815	1	< 0.1%
86814	1	< 0.1%
86813	1	< 0.1%

project code
Categorical

HIGH CARDINALITY

Distinct	142
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

116-ZA-T30	768
104-CI-T30	729
151-NG-T30	628
114-UG-T30	596
108-VN-T30	522
Other values (137)	7081

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	103240
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.1%

Sample

1st row	100-CI-T01
2nd row	108-VN-T01
3rd row	100-CI-T01
4th row	108-VN-T01
5th row	108-VN-T01

Common Values

Value	Count	Frequency (%)
116-ZA-T30	768	7.4%
104-CI-T30	729	7.1%
151-NG-T30	628	6.1%
114-UG-T30	596	5.8%
108-VN-T30	522	5.1%
106-HT-T30	450	4.4%
111-MZ-T30	431	4.2%
110-ZM-T30	406	3.9%
109-TZ-T30	369	3.6%
107-RW-T30	340	3.3%
Other values (132)	5085	49.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
116-za-t30	768	7.4%
104-ci-t30	729	7.1%
151-ng-t30	628	6.1%
114-ug-t30	596	5.8%
108-vn-t30	522	5.1%
106-ht-t30	450	4.4%
111-mz-t30	431	4.2%
110-zm-t30	406	3.9%
109-tz-t30	369	3.6%
107-rw-t30	340	3.3%
Other values (132)	5085	49.3%

Most occurring characters

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	51609	50.0%
Uppercase Letter	30983	30.0%
Dash Punctuation	20648	20.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	11732	37.9%
Z	3815	12.3%
G	2289	7.4%
N	1981	6.4%
A	1522	4.9%
C	1490	4.8%
M	1419	4.6%
I	1181	3.8%
W	1053	3.4%
U	779	2.5%
Other values (14)	3722	12.0%

Decimal Number

Value	Count	Frequency (%)
1	18694	36.2%
0	16409	31.8%
3	8596	16.7%
6	2032	3.9%
4	1852	3.6%
5	1070	2.1%
2	859	1.7%
9	740	1.4%
8	698	1.4%
7	659	1.3%

Dash Punctuation

Value	Count	Frequency (%)
-	20648	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	72257	70.0%
Latin	30983	30.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	11732	37.9%
Z	3815	12.3%
G	2289	7.4%
N	1981	6.4%
A	1522	4.9%
C	1490	4.8%
M	1419	4.6%
I	1181	3.8%
W	1053	3.4%
U	779	2.5%
Other values (14)	3722	12.0%

Common

Value	Count	Frequency (%)
-	20648	28.6%
1	18694	25.9%
0	16409	22.7%
3	8596	11.9%
6	2032	2.8%
4	1852	2.6%
5	1070	1.5%
2	859	1.2%
9	740	1.0%
8	698	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	103240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

pq #
Categorical

HIGH CARDINALITY

Distinct	1237
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Pre-PQ Process	2681
FPQ-14942	205
FPQ-12522	154
FPQ-13973	110
FPQ-4537	98
Other values (1232)	7076

Length

Max length	14
Median length	9
Mean length	9.946822937
Min length	8

Characters and Unicode

Total characters	102691
Distinct characters	20
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	380 ?
Unique (%)	3.7%

Sample

1st row	Pre-PQ Process
2nd row	Pre-PQ Process
3rd row	Pre-PQ Process
4th row	Pre-PQ Process
5th row	Pre-PQ Process

Common Values

Value	Count	Frequency (%)
Pre-PQ Process	2681	26.0%
FPQ-14942	205	2.0%
FPQ-12522	154	1.5%
FPQ-13973	110	1.1%
FPQ-4537	98	0.9%
FPQ-8840	90	0.9%
FPQ-5303	78	0.8%
FPQ-7175	78	0.8%
FPQ-6262	75	0.7%
FPQ-5023	70	0.7%
Other values (1227)	6685	64.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pre-pq	2681	20.6%
process	2681	20.6%
fpq-14942	205	1.6%
fpq-12522	154	1.2%
fpq-13973	110	0.8%
fpq-4537	98	0.8%
fpq-8840	90	0.7%
fpq-7175	78	0.6%
fpq-5303	78	0.6%
fpq-6262	75	0.6%
Other values (1228)	6755	51.9%

Most occurring characters

Value	Count	Frequency (%)
P	15686	15.3%
Q	10324	10.1%
-	10324	10.1%
F	7643	7.4%
1	6503	6.3%
s	5362	5.2%
e	5362	5.2%
r	5362	5.2%
2	3851	3.8%
4	3824	3.7%
Other values (10)	28450	27.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	34585	33.7%
Uppercase Letter	33653	32.8%
Lowercase Letter	21448	20.9%
Dash Punctuation	10324	10.1%
Space Separator	2681	2.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	6503	18.8%
2	3851	11.1%
4	3824	11.1%
5	3412	9.9%
3	3326	9.6%
6	2890	8.4%
0	2787	8.1%
9	2745	7.9%
8	2712	7.8%
7	2535	7.3%

Lowercase Letter

Value	Count	Frequency (%)
s	5362	25.0%
e	5362	25.0%
r	5362	25.0%
o	2681	12.5%
c	2681	12.5%

Uppercase Letter

Value	Count	Frequency (%)
P	15686	46.6%
Q	10324	30.7%
F	7643	22.7%

Dash Punctuation

Value	Count	Frequency (%)
-	10324	100.0%

Space Separator

Value	Count	Frequency (%)
	2681	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	55101	53.7%
Common	47590	46.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	10324	21.7%
1	6503	13.7%
2	3851	8.1%
4	3824	8.0%
5	3412	7.2%
3	3326	7.0%
6	2890	6.1%
0	2787	5.9%
9	2745	5.8%
8	2712	5.7%
Other values (2)	5216	11.0%

Latin

Value	Count	Frequency (%)
P	15686	28.5%
Q	10324	18.7%
F	7643	13.9%
s	5362	9.7%
e	5362	9.7%
r	5362	9.7%
o	2681	4.9%
c	2681	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	15686	15.3%
Q	10324	10.1%
-	10324	10.1%
F	7643	7.4%
1	6503	6.3%
s	5362	5.2%
e	5362	5.2%
r	5362	5.2%
2	3851	3.8%
4	3824	3.7%
Other values (10)	28450	27.7%

po / so #
Categorical

HIGH CARDINALITY

Distinct	6233
Distinct (%)	60.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

SCMS-199289	67
SCMS-199283	63
SCMS-183950	55
SCMS-259075	38
SCMS-215370	38
Other values (6228)	10063

Length

Max length	11
Median length	10
Mean length	9.056567222
Min length	6

Characters and Unicode

Total characters	93500
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4540 ?
Unique (%)	44.0%

Sample

1st row	SCMS-4
2nd row	SCMS-13
3rd row	SCMS-20
4th row	SCMS-78
5th row	SCMS-81

Common Values

Value	Count	Frequency (%)
SCMS-199289	67	0.6%
SCMS-199283	63	0.6%
SCMS-183950	55	0.5%
SCMS-259075	38	0.4%
SCMS-215370	38	0.4%
SCMS-259079	33	0.3%
SCMS-23500	26	0.3%
SCMS-215410	26	0.3%
SCMS-259078	20	0.2%
SCMS-162440	20	0.2%
Other values (6223)	9938	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
scms-199289	67	0.6%
scms-199283	63	0.6%
scms-183950	55	0.5%
scms-259075	38	0.4%
scms-215370	38	0.4%
scms-259079	33	0.3%
scms-23500	26	0.3%
scms-215410	26	0.3%
scms-259078	20	0.2%
scms-162440	20	0.2%
Other values (6223)	9938	96.3%

Most occurring characters

Value	Count	Frequency (%)
S	15243	16.3%
-	10324	11.0%
0	10280	11.0%
1	6433	6.9%
4	6052	6.5%
2	5714	6.1%
3	5482	5.9%
O	5404	5.8%
C	4920	5.3%
M	4920	5.3%
Other values (6)	18728	20.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	52688	56.4%
Uppercase Letter	30488	32.6%
Dash Punctuation	10324	11.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	10280	19.5%
1	6433	12.2%
4	6052	11.5%
2	5714	10.8%
3	5482	10.4%
5	4241	8.0%
8	3850	7.3%
7	3657	6.9%
9	3634	6.9%
6	3345	6.3%

Uppercase Letter

Value	Count	Frequency (%)
S	15243	50.0%
O	5404	17.7%
C	4920	16.1%
M	4920	16.1%
D	1	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	10324	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	63012	67.4%
Latin	30488	32.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	10324	16.4%
0	10280	16.3%
1	6433	10.2%
4	6052	9.6%
2	5714	9.1%
3	5482	8.7%
5	4241	6.7%
8	3850	6.1%
7	3657	5.8%
9	3634	5.8%

Latin

Value	Count	Frequency (%)
S	15243	50.0%
O	5404	17.7%
C	4920	16.1%
M	4920	16.1%
D	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	15243	16.3%
-	10324	11.0%
0	10280	11.0%
1	6433	6.9%
4	6052	6.5%
2	5714	6.1%
3	5482	5.9%
O	5404	5.8%
C	4920	5.3%
M	4920	5.3%
Other values (6)	18728	20.0%

asn/dn #
Categorical

HIGH CARDINALITY

Distinct	7030
Distinct (%)	68.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

ASN-19166	54
ASN-24415	38
ASN-23875	26
ASN-32138	19
ASN-28036	17
Other values (7025)	10170

Length

Max length	9
Median length	8
Mean length	7.627179388
Min length	4

Characters and Unicode

Total characters	78743
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5580 ?
Unique (%)	54.0%

Sample

1st row	ASN-8
2nd row	ASN-85
3rd row	ASN-14
4th row	ASN-50
5th row	ASN-55

Common Values

Value	Count	Frequency (%)
ASN-19166	54	0.5%
ASN-24415	38	0.4%
ASN-23875	26	0.3%
ASN-32138	19	0.2%
ASN-28036	17	0.2%
ASN-28034	17	0.2%
DN-304	17	0.2%
ASN-28033	17	0.2%
ASN-30792	17	0.2%
ASN-7373	16	0.2%
Other values (7020)	10086	97.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
asn-19166	54	0.5%
asn-24415	38	0.4%
asn-23875	26	0.3%
asn-32138	19	0.2%
asn-28036	17	0.2%
asn-28034	17	0.2%
dn-304	17	0.2%
asn-28033	17	0.2%
asn-30792	17	0.2%
asn-1520	16	0.2%
Other values (7020)	10086	97.7%

Most occurring characters

Value	Count	Frequency (%)
N	10324	13.1%
-	10324	13.1%
2	6558	8.3%
1	6137	7.8%
3	5629	7.1%
D	5404	6.9%
A	4920	6.2%
S	4920	6.2%
4	3911	5.0%
7	3586	4.6%
Other values (5)	17030	21.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42851	54.4%
Uppercase Letter	25568	32.5%
Dash Punctuation	10324	13.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	6558	15.3%
1	6137	14.3%
3	5629	13.1%
4	3911	9.1%
7	3586	8.4%
5	3562	8.3%
6	3422	8.0%
8	3372	7.9%
9	3351	7.8%
0	3323	7.8%

Uppercase Letter

Value	Count	Frequency (%)
N	10324	40.4%
D	5404	21.1%
A	4920	19.2%
S	4920	19.2%

Dash Punctuation

Value	Count	Frequency (%)
-	10324	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	53175	67.5%
Latin	25568	32.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	10324	19.4%
2	6558	12.3%
1	6137	11.5%
3	5629	10.6%
4	3911	7.4%
7	3586	6.7%
5	3562	6.7%
6	3422	6.4%
8	3372	6.3%
9	3351	6.3%

Latin

Value	Count	Frequency (%)
N	10324	40.4%
D	5404	21.1%
A	4920	19.2%
S	4920	19.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	78743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	10324	13.1%
-	10324	13.1%
2	6558	8.3%
1	6137	7.8%
3	5629	7.1%
D	5404	6.9%
A	4920	6.2%
S	4920	6.2%
4	3911	5.0%
7	3586	4.6%
Other values (5)	17030	21.6%

country
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	43
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

South Africa	1406
Nigeria	1194
Côte d'Ivoire	1083
Uganda	779
Vietnam	688
Other values (38)	5174

Length

Max length	18
Median length	12
Mean length	8.476268888
Min length	4

Characters and Unicode

Total characters	87509
Distinct characters	48
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Côte d'Ivoire
2nd row	Vietnam
3rd row	Côte d'Ivoire
4th row	Vietnam
5th row	Vietnam

Common Values

Value	Count	Frequency (%)
South Africa	1406	13.6%
Nigeria	1194	11.6%
Côte d'Ivoire	1083	10.5%
Uganda	779	7.5%
Vietnam	688	6.7%
Zambia	683	6.6%
Haiti	655	6.3%
Mozambique	631	6.1%
Zimbabwe	538	5.2%
Tanzania	519	5.0%
Other values (33)	2148	20.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
south	1570	11.7%
africa	1406	10.5%
nigeria	1194	8.9%
côte	1083	8.1%
d'ivoire	1083	8.1%
uganda	779	5.8%
vietnam	688	5.1%
zambia	683	5.1%
haiti	655	4.9%
mozambique	631	4.7%
Other values (38)	3596	26.9%

Most occurring characters

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	69015	78.9%
Uppercase Letter	14034	16.0%
Space Separator	3044	3.5%
Other Punctuation	1416	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	12282	17.8%
i	10247	14.8%
e	5522	8.0%
o	4473	6.5%
n	4350	6.3%
t	4323	6.3%
r	3874	5.6%
u	2914	4.2%
m	2777	4.0%
d	2635	3.8%
Other values (15)	15618	22.6%

Uppercase Letter

Value	Count	Frequency (%)
C	1824	13.0%
S	1822	13.0%
A	1416	10.1%
N	1289	9.2%
Z	1221	8.7%
I	1083	7.7%
R	815	5.8%
U	779	5.6%
V	688	4.9%
M	662	4.7%
Other values (10)	2435	17.4%

Other Punctuation

Value	Count	Frequency (%)
'	1083	76.5%
,	333	23.5%

Space Separator

Value	Count	Frequency (%)
	3044	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	83049	94.9%
Common	4460	5.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	12282	14.8%
i	10247	12.3%
e	5522	6.6%
o	4473	5.4%
n	4350	5.2%
t	4323	5.2%
r	3874	4.7%
u	2914	3.5%
m	2777	3.3%
d	2635	3.2%
Other values (35)	29652	35.7%

Common

Value	Count	Frequency (%)
	3044	68.3%
'	1083	24.3%
,	333	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86426	98.8%
Latin 1 Sup	1083	1.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	12282	14.2%
i	10247	11.9%
e	5522	6.4%
o	4473	5.2%
n	4350	5.0%
t	4323	5.0%
r	3874	4.5%
	3044	3.5%
u	2914	3.4%
m	2777	3.2%
Other values (37)	32620	37.7%

Latin 1 Sup

Value	Count	Frequency (%)
ô	1083	100.0%

managed by
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

PMO - US	10265
South Africa Field Office	57
Haiti Field Office	1
Ethiopia Field Office	1

Length

Max length	25
Median length	8
Mean length	8.096086788
Min length	8

Characters and Unicode

Total characters	83584
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	PMO - US
2nd row	PMO - US
3rd row	PMO - US
4th row	PMO - US
5th row	PMO - US

Common Values

Value	Count	Frequency (%)
PMO - US	10265	99.4%
South Africa Field Office	57	0.6%
Haiti Field Office	1	< 0.1%
Ethiopia Field Office	1	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
pmo	10265	33.1%
	10265	33.1%
us	10265	33.1%
field	59	0.2%
office	59	0.2%
south	57	0.2%
africa	57	0.2%
haiti	1	< 0.1%
ethiopia	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
P	10265	12.3%
M	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	51559	61.7%
Space Separator	20705	24.8%
Dash Punctuation	10265	12.3%
Lowercase Letter	1055	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	179	17.0%
f	175	16.6%
e	118	11.2%
c	116	11.0%
t	59	5.6%
a	59	5.6%
l	59	5.6%
d	59	5.6%
h	58	5.5%
o	58	5.5%
Other values (3)	115	10.9%

Uppercase Letter

Value	Count	Frequency (%)
O	10324	20.0%
S	10322	20.0%
P	10265	19.9%
M	10265	19.9%
U	10265	19.9%
F	59	0.1%
A	57	0.1%
H	1	< 0.1%
E	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	20705	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10265	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	52614	62.9%
Common	30970	37.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	10324	19.6%
S	10322	19.6%
P	10265	19.5%
M	10265	19.5%
U	10265	19.5%
i	179	0.3%
f	175	0.3%
e	118	0.2%
c	116	0.2%
t	59	0.1%
Other values (12)	526	1.0%

Common

Value	Count	Frequency (%)
	20705	66.9%
-	10265	33.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	83584	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
P	10265	12.3%
M	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

fulfill via
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

From RDC	5404
Direct Drop	4920

Length

Max length	11
Median length	8
Mean length	9.429678419
Min length	8

Characters and Unicode

Total characters	97352
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct Drop
2nd row	Direct Drop
3rd row	Direct Drop
4th row	Direct Drop
5th row	Direct Drop

Common Values

Value	Count	Frequency (%)
From RDC	5404	52.3%
Direct Drop	4920	47.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
from	5404	26.2%
rdc	5404	26.2%
direct	4920	23.8%
drop	4920	23.8%

Most occurring characters

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
o	10324	10.6%
	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	55572	57.1%
Uppercase Letter	31456	32.3%
Space Separator	10324	10.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	15244	27.4%
o	10324	18.6%
m	5404	9.7%
i	4920	8.9%
e	4920	8.9%
c	4920	8.9%
t	4920	8.9%
p	4920	8.9%

Uppercase Letter

Value	Count	Frequency (%)
D	15244	48.5%
F	5404	17.2%
R	5404	17.2%
C	5404	17.2%

Space Separator

Value	Count	Frequency (%)
	10324	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	87028	89.4%
Common	10324	10.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	15244	17.5%
D	15244	17.5%
o	10324	11.9%
F	5404	6.2%
m	5404	6.2%
R	5404	6.2%
C	5404	6.2%
i	4920	5.7%
e	4920	5.7%
c	4920	5.7%
Other values (2)	9840	11.3%

Common

Value	Count	Frequency (%)
	10324	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	97352	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
o	10324	10.6%
	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

vendor inco term
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

N/A - From RDC	5404
EXW	2778
DDP	1443
FCA	397
CIP	275
Other values (3)	27

Length

Max length	14
Median length	14
Mean length	8.757845796
Min length	3

Characters and Unicode

Total characters	90416
Distinct characters	18
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EXW
2nd row	EXW
3rd row	FCA
4th row	EXW
5th row	EXW

Common Values

Value	Count	Frequency (%)
N/A - From RDC	5404	52.3%
EXW	2778	26.9%
DDP	1443	14.0%
FCA	397	3.8%
CIP	275	2.7%
DDU	15	0.1%
DAP	9	0.1%
CIF	3	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n/a	5404	20.4%
	5404	20.4%
from	5404	20.4%
rdc	5404	20.4%
exw	2778	10.5%
ddp	1443	5.4%
fca	397	1.5%
cip	275	1.0%
ddu	15	0.1%
dap	9	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
m	5404	6.0%
/	5404	6.0%
R	5404	6.0%
o	5404	6.0%
Other values (8)	21162	23.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	47184	52.2%
Space Separator	16212	17.9%
Lowercase Letter	16212	17.9%
Other Punctuation	5404	6.0%
Dash Punctuation	5404	6.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	8329	17.7%
C	6079	12.9%
A	5810	12.3%
F	5804	12.3%
N	5404	11.5%
R	5404	11.5%
E	2778	5.9%
X	2778	5.9%
W	2778	5.9%
P	1727	3.7%
Other values (2)	293	0.6%

Lowercase Letter

Value	Count	Frequency (%)
m	5404	33.3%
o	5404	33.3%
r	5404	33.3%

Space Separator

Value	Count	Frequency (%)
	16212	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	5404	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5404	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	63396	70.1%
Common	27020	29.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	8329	13.1%
C	6079	9.6%
A	5810	9.2%
F	5804	9.2%
N	5404	8.5%
m	5404	8.5%
R	5404	8.5%
o	5404	8.5%
r	5404	8.5%
E	2778	4.4%
Other values (5)	7576	12.0%

Common

Value	Count	Frequency (%)
	16212	60.0%
/	5404	20.0%
-	5404	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90416	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
m	5404	6.0%
/	5404	6.0%
R	5404	6.0%
o	5404	6.0%
Other values (8)	21162	23.4%

shipment mode
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	360
Missing (%)	3.5%
Memory size	80.8 KiB

Air	6113
Truck	2830
Air Charter	650
Ocean	371

Length

Max length	11
Median length	3
Mean length	4.164391811
Min length	3

Characters and Unicode

Total characters	41494
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Air
2nd row	Air
3rd row	Air
4th row	Air
5th row	Air

Common Values

Value	Count	Frequency (%)
Air	6113	59.2%
Truck	2830	27.4%
Air Charter	650	6.3%
Ocean	371	3.6%
(Missing)	360	3.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
air	6763	63.7%
truck	2830	26.7%
charter	650	6.1%
ocean	371	3.5%

Most occurring characters

Value	Count	Frequency (%)
r	10893	26.3%
A	6763	16.3%
i	6763	16.3%
c	3201	7.7%
T	2830	6.8%
u	2830	6.8%
k	2830	6.8%
a	1021	2.5%
e	1021	2.5%
	650	1.6%
Other values (5)	2692	6.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	30230	72.9%
Uppercase Letter	10614	25.6%
Space Separator	650	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	10893	36.0%
i	6763	22.4%
c	3201	10.6%
u	2830	9.4%
k	2830	9.4%
a	1021	3.4%
e	1021	3.4%
h	650	2.2%
t	650	2.2%
n	371	1.2%

Uppercase Letter

Value	Count	Frequency (%)
A	6763	63.7%
T	2830	26.7%
C	650	6.1%
O	371	3.5%

Space Separator

Value	Count	Frequency (%)
	650	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40844	98.4%
Common	650	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	10893	26.7%
A	6763	16.6%
i	6763	16.6%
c	3201	7.8%
T	2830	6.9%
u	2830	6.9%
k	2830	6.9%
a	1021	2.5%
e	1021	2.5%
C	650	1.6%
Other values (4)	2042	5.0%

Common

Value	Count	Frequency (%)
	650	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41494	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	10893	26.3%
A	6763	16.3%
i	6763	16.3%
c	3201	7.7%
T	2830	6.8%
u	2830	6.8%
k	2830	6.8%
a	1021	2.5%
e	1021	2.5%
	650	1.6%
Other values (5)	2692	6.5%

pq first sent to client date
Categorical

HIGH CARDINALITY

Distinct	765
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Pre-PQ Process	2476
9/11/2014	205
Date Not Captured	205
7/11/2013	173
4/30/2014	123
Other values (760)	7142

Length

Max length	17
Median length	14
Mean length	10.35557923
Min length	8

Characters and Unicode

Total characters	106911
Distinct characters	28
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	133 ?
Unique (%)	1.3%

Sample

1st row	Pre-PQ Process
2nd row	Pre-PQ Process
3rd row	Pre-PQ Process
4th row	Pre-PQ Process
5th row	Pre-PQ Process

Common Values

Value	Count	Frequency (%)
Pre-PQ Process	2476	24.0%
9/11/2014	205	2.0%
Date Not Captured	205	2.0%
7/11/2013	173	1.7%
4/30/2014	123	1.2%
11/6/2009	98	0.9%
11/21/2011	90	0.9%
3/10/2011	89	0.9%
3/18/2010	78	0.8%
8/31/2010	75	0.7%
Other values (755)	6712	65.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pre-pq	2476	18.7%
process	2476	18.7%
9/11/2014	205	1.6%
date	205	1.6%
not	205	1.6%
captured	205	1.6%
7/11/2013	173	1.3%
4/30/2014	123	0.9%
11/6/2009	98	0.7%
11/21/2011	90	0.7%
Other values (758)	6954	52.6%

Most occurring characters

Value	Count	Frequency (%)
1	15328	14.3%
/	15286	14.3%
2	12611	11.8%
0	11326	10.6%
P	7428	6.9%
e	5362	5.0%
r	5157	4.8%
s	4952	4.6%
3	3479	3.3%
4	2986	2.8%
Other values (18)	22996	21.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53476	50.0%
Lowercase Letter	22268	20.8%
Other Punctuation	15286	14.3%
Uppercase Letter	10519	9.8%
Space Separator	2886	2.7%
Dash Punctuation	2476	2.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	15328	28.7%
2	12611	23.6%
0	11326	21.2%
3	3479	6.5%
4	2986	5.6%
9	2280	4.3%
5	1516	2.8%
8	1508	2.8%
7	1283	2.4%
6	1159	2.2%

Lowercase Letter

Value	Count	Frequency (%)
e	5362	24.1%
r	5157	23.2%
s	4952	22.2%
o	2681	12.0%
c	2476	11.1%
t	615	2.8%
a	410	1.8%
p	205	0.9%
u	205	0.9%
d	205	0.9%

Uppercase Letter

Value	Count	Frequency (%)
P	7428	70.6%
Q	2476	23.5%
N	205	1.9%
D	205	1.9%
C	205	1.9%

Other Punctuation

Value	Count	Frequency (%)
/	15286	100.0%

Space Separator

Value	Count	Frequency (%)
	2886	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2476	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	74124	69.3%
Latin	32787	30.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	7428	22.7%
e	5362	16.4%
r	5157	15.7%
s	4952	15.1%
o	2681	8.2%
c	2476	7.6%
Q	2476	7.6%
t	615	1.9%
a	410	1.3%
N	205	0.6%
Other values (5)	1025	3.1%

Common

Value	Count	Frequency (%)
1	15328	20.7%
/	15286	20.6%
2	12611	17.0%
0	11326	15.3%
3	3479	4.7%
4	2986	4.0%
	2886	3.9%
-	2476	3.3%
9	2280	3.1%
5	1516	2.0%
Other values (3)	3950	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	106911	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	15328	14.3%
/	15286	14.3%
2	12611	11.8%
0	11326	10.6%
P	7428	6.9%
e	5362	5.0%
r	5157	4.8%
s	4952	4.6%
3	3479	3.3%
4	2986	2.8%
Other values (18)	22996	21.5%

po sent to vendor date
Categorical

HIGH CARDINALITY

Distinct	897
Distinct (%)	8.7%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

N/A - From RDC	5404
Date Not Captured	328
8/27/2014	80
3/19/2010	78
8/29/2014	76
Other values (892)	4358

Length

Max length	17
Median length	14
Mean length	11.84996126
Min length	8

Characters and Unicode

Total characters	122339
Distinct characters	28
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	256 ?
Unique (%)	2.5%

Sample

1st row	Date Not Captured
2nd row	Date Not Captured
3rd row	Date Not Captured
4th row	Date Not Captured
5th row	Date Not Captured

Common Values

Value	Count	Frequency (%)
N/A - From RDC	5404	52.3%
Date Not Captured	328	3.2%
8/27/2014	80	0.8%
3/19/2010	78	0.8%
8/29/2014	76	0.7%
10/9/2014	71	0.7%
12/2/2013	67	0.6%
9/24/2010	53	0.5%
2/20/2015	43	0.4%
5/11/2015	40	0.4%
Other values (887)	4084	39.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
n/a	5404	19.9%
	5404	19.9%
from	5404	19.9%
rdc	5404	19.9%
date	328	1.2%
not	328	1.2%
captured	328	1.2%
8/27/2014	80	0.3%
3/19/2010	78	0.3%
8/29/2014	76	0.3%
Other values (892)	4358	16.0%

Most occurring characters

Value	Count	Frequency (%)
	16868	13.8%
/	14588	11.9%
2	7921	6.5%
1	7602	6.2%
0	7063	5.8%
o	5732	4.7%
D	5732	4.7%
N	5732	4.7%
r	5732	4.7%
C	5732	4.7%
Other values (18)	39637	32.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	33408	27.3%
Decimal Number	31923	26.1%
Lowercase Letter	20148	16.5%
Space Separator	16868	13.8%
Other Punctuation	14588	11.9%
Dash Punctuation	5404	4.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	7921	24.8%
1	7602	23.8%
0	7063	22.1%
3	1863	5.8%
4	1840	5.8%
9	1471	4.6%
8	1339	4.2%
5	1181	3.7%
7	972	3.0%
6	671	2.1%

Lowercase Letter

Value	Count	Frequency (%)
o	5732	28.4%
r	5732	28.4%
m	5404	26.8%
t	984	4.9%
a	656	3.3%
e	656	3.3%
d	328	1.6%
u	328	1.6%
p	328	1.6%

Uppercase Letter

Value	Count	Frequency (%)
D	5732	17.2%
N	5732	17.2%
C	5732	17.2%
R	5404	16.2%
F	5404	16.2%
A	5404	16.2%

Space Separator

Value	Count	Frequency (%)
	16868	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	14588	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5404	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	68783	56.2%
Latin	53556	43.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	5732	10.7%
D	5732	10.7%
N	5732	10.7%
r	5732	10.7%
C	5732	10.7%
m	5404	10.1%
R	5404	10.1%
F	5404	10.1%
A	5404	10.1%
t	984	1.8%
Other values (5)	2296	4.3%

Common

Value	Count	Frequency (%)
	16868	24.5%
/	14588	21.2%
2	7921	11.5%
1	7602	11.1%
0	7063	10.3%
-	5404	7.9%
3	1863	2.7%
4	1840	2.7%
9	1471	2.1%
8	1339	1.9%
Other values (3)	2824	4.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	122339	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	16868	13.8%
/	14588	11.9%
2	7921	6.5%
1	7602	6.2%
0	7063	5.8%
o	5732	4.7%
D	5732	4.7%
N	5732	4.7%
r	5732	4.7%
C	5732	4.7%
Other values (18)	39637	32.4%

scheduled delivery date
Categorical

HIGH CARDINALITY

Distinct	2006
Distinct (%)	19.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

29-Aug-14	97
16-Mar-12	83
27-Aug-14	63
31-May-10	62
31-Jan-14	60
Other values (2001)	9959

Length

Max length	9
Median length	9
Mean length	8.754455637
Min length	8

Characters and Unicode

Total characters	90381
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	492 ?
Unique (%)	4.8%

Sample

1st row	2-Jun-06
2nd row	14-Nov-06
3rd row	27-Aug-06
4th row	1-Sep-06
5th row	11-Aug-06

Common Values

Value	Count	Frequency (%)
29-Aug-14	97	0.9%
16-Mar-12	83	0.8%
27-Aug-14	63	0.6%
31-May-10	62	0.6%
31-Jan-14	60	0.6%
30-Sep-14	57	0.6%
16-Apr-13	56	0.5%
15-Jul-10	55	0.5%
19-Apr-10	53	0.5%
24-Aug-15	51	0.5%
Other values (1996)	9687	93.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
29-aug-14	97	0.9%
16-mar-12	83	0.8%
27-aug-14	63	0.6%
31-may-10	62	0.6%
31-jan-14	60	0.6%
30-sep-14	57	0.6%
16-apr-13	56	0.5%
15-jul-10	55	0.5%
19-apr-10	53	0.5%
24-aug-15	51	0.5%
Other values (1996)	9687	93.8%

Most occurring characters

Value	Count	Frequency (%)
-	20648	22.8%
1	12920	14.3%
0	5704	6.3%
2	5279	5.8%
3	3605	4.0%
u	2949	3.3%
J	2584	2.9%
a	2522	2.8%
4	2483	2.7%
9	2351	2.6%
Other values (23)	29336	32.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	38761	42.9%
Dash Punctuation	20648	22.8%
Lowercase Letter	20648	22.8%
Uppercase Letter	10324	11.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	2949	14.3%
a	2522	12.2%
e	2283	11.1%
r	1964	9.5%
p	1847	8.9%
n	1667	8.1%
c	1502	7.3%
g	1081	5.2%
l	917	4.4%
t	822	4.0%
Other values (4)	3094	15.0%

Decimal Number

Value	Count	Frequency (%)
1	12920	33.3%
0	5704	14.7%
2	5279	13.6%
3	3605	9.3%
4	2483	6.4%
9	2351	6.1%
5	1970	5.1%
8	1918	4.9%
7	1572	4.1%
6	959	2.5%

Uppercase Letter

Value	Count	Frequency (%)
J	2584	25.0%
A	2044	19.8%
M	1806	17.5%
S	884	8.6%
O	822	8.0%
N	785	7.6%
F	719	7.0%
D	680	6.6%

Dash Punctuation

Value	Count	Frequency (%)
-	20648	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	59409	65.7%
Latin	30972	34.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	2949	9.5%
J	2584	8.3%
a	2522	8.1%
e	2283	7.4%
A	2044	6.6%
r	1964	6.3%
p	1847	6.0%
M	1806	5.8%
n	1667	5.4%
c	1502	4.8%
Other values (12)	9804	31.7%

Common

Value	Count	Frequency (%)
-	20648	34.8%
1	12920	21.7%
0	5704	9.6%
2	5279	8.9%
3	3605	6.1%
4	2483	4.2%
9	2351	4.0%
5	1970	3.3%
8	1918	3.2%
7	1572	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90381	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	20648	22.8%
1	12920	14.3%
0	5704	6.3%
2	5279	5.8%
3	3605	4.0%
u	2949	3.3%
J	2584	2.9%
a	2522	2.8%
4	2483	2.7%
9	2351	2.6%
Other values (23)	29336	32.5%

delivered to client date
Categorical

HIGH CARDINALITY

Distinct	2093
Distinct (%)	20.3%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

29-Aug-14	74
27-Aug-14	66
28-Jun-10	60
14-Feb-12	60
16-Apr-13	59
Other values (2088)	10005

Length

Max length	9
Median length	9
Mean length	8.717938783
Min length	8

Characters and Unicode

Total characters	90004
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	474 ?
Unique (%)	4.6%

Sample

1st row	2-Jun-06
2nd row	14-Nov-06
3rd row	27-Aug-06
4th row	1-Sep-06
5th row	11-Aug-06

Common Values

Value	Count	Frequency (%)
29-Aug-14	74	0.7%
27-Aug-14	66	0.6%
28-Jun-10	60	0.6%
14-Feb-12	60	0.6%
16-Apr-13	59	0.6%
31-Mar-10	52	0.5%
24-Aug-15	51	0.5%
12-May-15	41	0.4%
18-May-10	41	0.4%
6-Feb-14	39	0.4%
Other values (2083)	9781	94.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
29-aug-14	74	0.7%
27-aug-14	66	0.6%
28-jun-10	60	0.6%
14-feb-12	60	0.6%
16-apr-13	59	0.6%
31-mar-10	52	0.5%
24-aug-15	51	0.5%
18-may-10	41	0.4%
12-may-15	41	0.4%
6-feb-14	39	0.4%
Other values (2083)	9781	94.7%

Most occurring characters

Value	Count	Frequency (%)
-	20648	22.9%
1	12777	14.2%
2	5679	6.3%
0	5284	5.9%
u	2829	3.1%
4	2823	3.1%
3	2810	3.1%
a	2518	2.8%
J	2490	2.8%
e	2420	2.7%
Other values (23)	29726	33.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	38384	42.6%
Dash Punctuation	20648	22.9%
Lowercase Letter	20648	22.9%
Uppercase Letter	10324	11.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	2829	13.7%
a	2518	12.2%
e	2420	11.7%
r	1863	9.0%
p	1751	8.5%
n	1618	7.8%
c	1562	7.6%
g	1030	5.0%
l	872	4.2%
t	867	4.2%
Other values (4)	3318	16.1%

Decimal Number

Value	Count	Frequency (%)
1	12777	33.3%
2	5679	14.8%
0	5284	13.8%
4	2823	7.4%
3	2810	7.3%
9	2268	5.9%
8	2192	5.7%
5	1959	5.1%
7	1673	4.4%
6	919	2.4%

Uppercase Letter

Value	Count	Frequency (%)
J	2490	24.1%
A	1921	18.6%
M	1827	17.7%
O	867	8.4%
F	865	8.4%
S	860	8.3%
N	799	7.7%
D	695	6.7%

Dash Punctuation

Value	Count	Frequency (%)
-	20648	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	59032	65.6%
Latin	30972	34.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	2829	9.1%
a	2518	8.1%
J	2490	8.0%
e	2420	7.8%
A	1921	6.2%
r	1863	6.0%
M	1827	5.9%
p	1751	5.7%
n	1618	5.2%
c	1562	5.0%
Other values (12)	10173	32.8%

Common

Value	Count	Frequency (%)
-	20648	35.0%
1	12777	21.6%
2	5679	9.6%
0	5284	9.0%
4	2823	4.8%
3	2810	4.8%
9	2268	3.8%
8	2192	3.7%
5	1959	3.3%
7	1673	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90004	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	20648	22.9%
1	12777	14.2%
2	5679	6.3%
0	5284	5.9%
u	2829	3.1%
4	2823	3.1%
3	2810	3.1%
a	2518	2.8%
J	2490	2.8%
e	2420	2.7%
Other values (23)	29726	33.0%

delivery recorded date
Categorical

HIGH CARDINALITY

Distinct	2042
Distinct (%)	19.8%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

29-Aug-14	67
27-Aug-14	66
14-Feb-12	60
28-Jun-10	60
16-Apr-13	59
Other values (2037)	10012

Length

Max length	9
Median length	9
Mean length	8.719004262
Min length	8

Characters and Unicode

Total characters	90015
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	468 ?
Unique (%)	4.5%

Sample

1st row	2-Jun-06
2nd row	14-Nov-06
3rd row	27-Aug-06
4th row	1-Sep-06
5th row	11-Aug-06

Common Values

Value	Count	Frequency (%)
29-Aug-14	67	0.6%
27-Aug-14	66	0.6%
14-Feb-12	60	0.6%
28-Jun-10	60	0.6%
16-Apr-13	59	0.6%
31-Mar-10	52	0.5%
24-Aug-15	50	0.5%
18-May-10	41	0.4%
12-May-15	40	0.4%
7-Nov-14	39	0.4%
Other values (2032)	9790	94.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
29-aug-14	67	0.6%
27-aug-14	66	0.6%
14-feb-12	60	0.6%
28-jun-10	60	0.6%
16-apr-13	59	0.6%
31-mar-10	52	0.5%
24-aug-15	50	0.5%
18-may-10	41	0.4%
12-may-15	40	0.4%
7-nov-14	39	0.4%
Other values (2032)	9790	94.8%

Most occurring characters

Value	Count	Frequency (%)
-	20648	22.9%
1	12905	14.3%
2	5632	6.3%
0	5247	5.8%
u	2877	3.2%
4	2813	3.1%
3	2757	3.1%
a	2533	2.8%
J	2520	2.8%
e	2375	2.6%
Other values (23)	29708	33.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	38395	42.7%
Dash Punctuation	20648	22.9%
Lowercase Letter	20648	22.9%
Uppercase Letter	10324	11.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	2877	13.9%
a	2533	12.3%
e	2375	11.5%
r	1891	9.2%
p	1720	8.3%
n	1649	8.0%
c	1502	7.3%
g	1045	5.1%
o	880	4.3%
v	880	4.3%
Other values (4)	3296	16.0%

Decimal Number

Value	Count	Frequency (%)
1	12905	33.6%
2	5632	14.7%
0	5247	13.7%
4	2813	7.3%
3	2757	7.2%
9	2240	5.8%
8	2155	5.6%
5	1918	5.0%
7	1745	4.5%
6	983	2.6%

Uppercase Letter

Value	Count	Frequency (%)
J	2520	24.4%
A	1912	18.5%
M	1845	17.9%
N	880	8.5%
S	853	8.3%
F	812	7.9%
O	792	7.7%
D	710	6.9%

Dash Punctuation

Value	Count	Frequency (%)
-	20648	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	59043	65.6%
Latin	30972	34.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	2877	9.3%
a	2533	8.2%
J	2520	8.1%
e	2375	7.7%
A	1912	6.2%
r	1891	6.1%
M	1845	6.0%
p	1720	5.6%
n	1649	5.3%
c	1502	4.8%
Other values (12)	10148	32.8%

Common

Value	Count	Frequency (%)
-	20648	35.0%
1	12905	21.9%
2	5632	9.5%
0	5247	8.9%
4	2813	4.8%
3	2757	4.7%
9	2240	3.8%
8	2155	3.6%
5	1918	3.2%
7	1745	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90015	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	20648	22.9%
1	12905	14.3%
2	5632	6.3%
0	5247	5.8%
u	2877	3.2%
4	2813	3.1%
3	2757	3.1%
a	2533	2.8%
J	2520	2.8%
e	2375	2.6%
Other values (23)	29708	33.0%

product group
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

ARV	8550
HRDT	1728
ANTM	22
ACT	16
MRDT	8

Length

Max length	4
Median length	3
Mean length	3.170282836
Min length	3

Characters and Unicode

Total characters	32730
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HRDT
2nd row	ARV
3rd row	HRDT
4th row	ARV
5th row	ARV

Common Values

Value	Count	Frequency (%)
ARV	8550	82.8%
HRDT	1728	16.7%
ANTM	22	0.2%
ACT	16	0.2%
MRDT	8	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
arv	8550	82.8%
hrdt	1728	16.7%
antm	22	0.2%
act	16	0.2%
mrdt	8	0.1%

Most occurring characters

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	32730	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	32730	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32730	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

sub classification
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Adult	6595
Pediatric	1955
HIV test	1567
HIV test - Ancillary	161
Malaria	30

Length

Max length	20
Median length	5
Mean length	6.449438202
Min length	3

Characters and Unicode

Total characters	66584
Distinct characters	22
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HIV test
2nd row	Pediatric
3rd row	HIV test
4th row	Adult
5th row	Adult

Common Values

Value	Count	Frequency (%)
Adult	6595	63.9%
Pediatric	1955	18.9%
HIV test	1567	15.2%
HIV test - Ancillary	161	1.6%
Malaria	30	0.3%
ACT	16	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
adult	6595	53.3%
pediatric	1955	15.8%
hiv	1728	14.0%
test	1728	14.0%
	161	1.3%
ancillary	161	1.3%
malaria	30	0.2%
act	16	0.1%

Most occurring characters

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	50400	75.7%
Uppercase Letter	13973	21.0%
Space Separator	2050	3.1%
Dash Punctuation	161	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	12006	23.8%
d	8550	17.0%
l	6947	13.8%
u	6595	13.1%
i	4101	8.1%
e	3683	7.3%
a	2206	4.4%
r	2146	4.3%
c	2116	4.2%
s	1728	3.4%
Other values (2)	322	0.6%

Uppercase Letter

Value	Count	Frequency (%)
A	6772	48.5%
P	1955	14.0%
H	1728	12.4%
V	1728	12.4%
I	1728	12.4%
M	30	0.2%
C	16	0.1%
T	16	0.1%

Space Separator

Value	Count	Frequency (%)
	2050	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	161	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	64373	96.7%
Common	2211	3.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	12006	18.7%
d	8550	13.3%
l	6947	10.8%
A	6772	10.5%
u	6595	10.2%
i	4101	6.4%
e	3683	5.7%
a	2206	3.4%
r	2146	3.3%
c	2116	3.3%
Other values (10)	9251	14.4%

Common

Value	Count	Frequency (%)
	2050	92.7%
-	161	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66584	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

vendor
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	73
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

SCMS from RDC	5404
Orgenics, Ltd	754
S. BUYS WHOLESALER	715
Aurobindo Pharma Limited	668
Trinity Biotech, Plc	356
Other values (68)	2427

Length

Max length	65
Median length	13
Mean length	18.53332042
Min length	7

Characters and Unicode

Total characters	191338
Distinct characters	54
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.2%

Sample

1st row	RANBAXY Fine Chemicals LTD.
2nd row	Aurobindo Pharma Limited
3rd row	Abbott GmbH & Co. KG
4th row	SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED)
5th row	Aurobindo Pharma Limited

Common Values

Value	Count	Frequency (%)
SCMS from RDC	5404	52.3%
Orgenics, Ltd	754	7.3%
S. BUYS WHOLESALER	715	6.9%
Aurobindo Pharma Limited	668	6.5%
Trinity Biotech, Plc	356	3.4%
ABBVIE LOGISTICS (FORMERLY ABBOTT LOGISTICS BV)	347	3.4%
PHARMACY DIRECT	326	3.2%
MYLAN LABORATORIES LTD (FORMERLY MATRIX LABORATORIES)	317	3.1%
HETERO LABS LIMITED	277	2.7%
CIPLA LIMITED	175	1.7%
Other values (63)	985	9.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
scms	5404	16.5%
rdc	5404	16.5%
from	5404	16.5%
limited	1288	3.9%
ltd	1169	3.6%
orgenics	754	2.3%
s	717	2.2%
buys	715	2.2%
wholesaler	715	2.2%
laboratories	705	2.2%
Other values (158)	10470	32.0%

Most occurring characters

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	113980	59.6%
Lowercase Letter	49941	26.1%
Space Separator	22491	11.8%
Other Punctuation	3054	1.6%
Open Punctuation	876	0.5%
Close Punctuation	875	0.5%
Dash Punctuation	120	0.1%
Decimal Number	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	16965	14.9%
C	13420	11.8%
R	11481	10.1%
M	8653	7.6%
D	7485	6.6%
L	7380	6.5%
A	6789	6.0%
I	6343	5.6%
E	6253	5.5%
O	5958	5.2%
Other values (16)	23253	20.4%

Lowercase Letter

Value	Count	Frequency (%)
r	8112	16.2%
o	7434	14.9%
m	6798	13.6%
f	5450	10.9%
i	4120	8.2%
t	2421	4.8%
d	2333	4.7%
n	2244	4.5%
e	2034	4.1%
c	1811	3.6%
Other values (9)	7184	14.4%

Other Punctuation

Value	Count	Frequency (%)
,	1438	47.1%
.	1406	46.0%
&	207	6.8%
/	3	0.1%

Space Separator

Value	Count	Frequency (%)
	22491	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	876	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	875	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	120	100.0%

Decimal Number

Value	Count	Frequency (%)
1	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	163921	85.7%
Common	27417	14.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	16965	10.3%
C	13420	8.2%
R	11481	7.0%
M	8653	5.3%
r	8112	4.9%
D	7485	4.6%
o	7434	4.5%
L	7380	4.5%
m	6798	4.1%
A	6789	4.1%
Other values (35)	69404	42.3%

Common

Value	Count	Frequency (%)
	22491	82.0%
,	1438	5.2%
.	1406	5.1%
(	876	3.2%
)	875	3.2%
&	207	0.8%
-	120	0.4%
/	3	< 0.1%
1	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	191338	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

item description
Categorical

HIGH CARDINALITY

Distinct	184
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Efavirenz 600mg, tablets, 30 Tabs	755
Nevirapine 200mg, tablets, 60 Tabs	623
Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	597
Lamivudine/Nevirapine/Zidovudine 150/200/300mg, tablets, 60 Tabs	580
HIV 1/2, Determine Complete HIV Kit, 100 Tests	577
Other values (179)	7192

Length

Max length	113
Median length	79
Mean length	50.14480821
Min length	31

Characters and Unicode

Total characters	517695
Distinct characters	73
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23 ?
Unique (%)	0.2%

Sample

1st row	HIV, Reveal G3 Rapid HIV-1 Antibody Test, 30 Tests
2nd row	Nevirapine 10mg/ml, oral suspension, Bottle, 240 ml
3rd row	HIV 1/2, Determine Complete HIV Kit, 100 Tests
4th row	Lamivudine 150mg, tablets, 60 Tabs
5th row	Stavudine 30mg, capsules, 60 Caps

Common Values

Value	Count	Frequency (%)
Efavirenz 600mg, tablets, 30 Tabs	755	7.3%
Nevirapine 200mg, tablets, 60 Tabs	623	6.0%
Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	597	5.8%
Lamivudine/Nevirapine/Zidovudine 150/200/300mg, tablets, 60 Tabs	580	5.6%
HIV 1/2, Determine Complete HIV Kit, 100 Tests	577	5.6%
Lamivudine 150mg, tablets, 60 Tabs	378	3.7%
HIV 1/2, Uni-Gold HIV Kit, 20 Tests	369	3.6%
Zidovudine 300mg, tablets, 60 Tabs	317	3.1%
Lamivudine/Tenofovir Disoproxil Fumarate 300/300mg, tablets, 30 Tabs	301	2.9%
Abacavir 300mg, tablets, 60 Tabs	287	2.8%
Other values (174)	5540	53.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tablets	6733	10.3%
tabs	6711	10.2%
60	4269	6.5%
hiv	3006	4.6%
30	2598	4.0%
tests	1616	2.5%
kit	1579	2.4%
1/2	1524	2.3%
disoproxil	1300	2.0%
fumarate	1300	2.0%
Other values (289)	34956	53.3%

Most occurring characters

Value	Count	Frequency (%)
	55268	10.7%
i	33699	6.5%
a	33528	6.5%
0	33249	6.4%
e	33073	6.4%
t	26685	5.2%
s	24970	4.8%
,	22576	4.4%
l	17483	3.4%
n	17399	3.4%
Other values (63)	219765	42.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	313250	60.5%
Decimal Number	65180	12.6%
Space Separator	55268	10.7%
Uppercase Letter	43918	8.5%
Other Punctuation	36237	7.0%
Open Punctuation	1507	0.3%
Close Punctuation	1507	0.3%
Dash Punctuation	764	0.1%
Math Symbol	64	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	33699	10.8%
a	33528	10.7%
e	33073	10.6%
t	26685	8.5%
s	24970	8.0%
l	17483	5.6%
n	17399	5.6%
m	17064	5.4%
o	15781	5.0%
b	15186	4.8%
Other values (16)	78382	25.0%

Uppercase Letter

Value	Count	Frequency (%)
T	9901	22.5%
L	4176	9.5%
V	3366	7.7%
I	3344	7.6%
H	3086	7.0%
D	2581	5.9%
E	2144	4.9%
Z	2052	4.7%
N	2045	4.7%
C	1971	4.5%
Other values (13)	9252	21.1%

Decimal Number

Value	Count	Frequency (%)
0	33249	51.0%
3	7689	11.8%
2	6712	10.3%
1	6430	9.9%
6	5928	9.1%
5	3521	5.4%
4	991	1.5%
8	366	0.6%
9	241	0.4%
7	53	0.1%

Other Punctuation

Value	Count	Frequency (%)
,	22576	62.3%
/	13314	36.7%
.	220	0.6%
*	84	0.2%
#	42	0.1%
&	1	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
[	1445	95.9%
(	62	4.1%

Close Punctuation

Value	Count	Frequency (%)
]	1445	95.9%
)	62	4.1%

Math Symbol

Value	Count	Frequency (%)
+	62	96.9%
\|	2	3.1%

Space Separator

Value	Count	Frequency (%)
	55268	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	764	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	357168	69.0%
Common	160527	31.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	33699	9.4%
a	33528	9.4%
e	33073	9.3%
t	26685	7.5%
s	24970	7.0%
l	17483	4.9%
n	17399	4.9%
m	17064	4.8%
o	15781	4.4%
b	15186	4.3%
Other values (39)	122300	34.2%

Common

Value	Count	Frequency (%)
	55268	34.4%
0	33249	20.7%
,	22576	14.1%
/	13314	8.3%
3	7689	4.8%
2	6712	4.2%
1	6430	4.0%
6	5928	3.7%
5	3521	2.2%
[	1445	0.9%
Other values (14)	4395	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	517695	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	55268	10.7%
i	33699	6.5%
a	33528	6.5%
0	33249	6.4%
e	33073	6.4%
t	26685	5.2%
s	24970	4.8%
,	22576	4.4%
l	17483	3.4%
n	17399	3.4%
Other values (63)	219765	42.5%

molecule/test type
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	86
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Efavirenz	1125
Nevirapine	877
Lamivudine/Nevirapine/Zidovudine	707
Lamivudine/Zidovudine	689
Lopinavir/Ritonavir	633
Other values (81)	6293

Length

Max length	98
Median length	60
Mean length	22.1509105
Min length	7

Characters and Unicode

Total characters	228686
Distinct characters	63
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	0.1%

Sample

1st row	HIV, Reveal G3 Rapid HIV-1 Antibody Test
2nd row	Nevirapine
3rd row	HIV 1/2, Determine Complete HIV Kit
4th row	Lamivudine
5th row	Stavudine

Common Values

Value	Count	Frequency (%)
Efavirenz	1125	10.9%
Nevirapine	877	8.5%
Lamivudine/Nevirapine/Zidovudine	707	6.8%
Lamivudine/Zidovudine	689	6.7%
Lopinavir/Ritonavir	633	6.1%
Lamivudine	592	5.7%
HIV 1/2, Determine Complete HIV Kit	577	5.6%
Zidovudine	529	5.1%
Abacavir	453	4.4%
HIV 1/2, Uni-Gold HIV Kit	369	3.6%
Other values (76)	3773	36.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hiv	3055	13.6%
kit	1579	7.0%
1/2	1524	6.8%
disoproxil	1300	5.8%
fumarate	1300	5.8%
efavirenz	1125	5.0%
nevirapine	877	3.9%
determine	799	3.6%
lamivudine/nevirapine/zidovudine	707	3.2%
lamivudine/zidovudine	689	3.1%
Other values (148)	9451	42.2%

Most occurring characters

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	169993	74.3%
Uppercase Letter	32022	14.0%
Space Separator	12082	5.3%
Other Punctuation	9777	4.3%
Decimal Number	4138	1.8%
Dash Punctuation	572	0.3%
Open Punctuation	39	< 0.1%
Close Punctuation	39	< 0.1%
Math Symbol	24	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	30297	17.8%
e	19499	11.5%
a	15535	9.1%
n	15469	9.1%
v	13084	7.7%
r	11537	6.8%
o	10997	6.5%
d	9170	5.4%
t	8291	4.9%
u	7804	4.6%
Other values (15)	28310	16.7%

Uppercase Letter

Value	Count	Frequency (%)
L	4176	13.0%
I	3245	10.1%
V	3176	9.9%
H	3120	9.7%
D	2573	8.0%
E	2061	6.4%
Z	1969	6.1%
N	1901	5.9%
K	1579	4.9%
T	1515	4.7%
Other values (13)	6707	20.9%

Decimal Number

Value	Count	Frequency (%)
1	1786	43.2%
2	1644	39.7%
0	478	11.6%
3	148	3.6%
5	82	2.0%

Other Punctuation

Value	Count	Frequency (%)
/	6734	68.9%
,	2836	29.0%
.	206	2.1%
&	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	22	91.7%
\|	2	8.3%

Space Separator

Value	Count	Frequency (%)
	12082	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	572	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	39	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	39	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	202015	88.3%
Common	26671	11.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	30297	15.0%
e	19499	9.7%
a	15535	7.7%
n	15469	7.7%
v	13084	6.5%
r	11537	5.7%
o	10997	5.4%
d	9170	4.5%
t	8291	4.1%
u	7804	3.9%
Other values (38)	60332	29.9%

Common

Value	Count	Frequency (%)
	12082	45.3%
/	6734	25.2%
,	2836	10.6%
1	1786	6.7%
2	1644	6.2%
-	572	2.1%
0	478	1.8%
.	206	0.8%
3	148	0.6%
5	82	0.3%
Other values (5)	103	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	228686	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

brand
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	48
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Generic	7285
Determine	799
Uni-Gold	373
Aluvia	250
Kaletra	165
Other values (43)	1452

Length

Max length	15
Median length	7
Mean length	7.287969779
Min length	3

Characters and Unicode

Total characters	75241
Distinct characters	48
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Reveal
2nd row	Generic
3rd row	Determine
4th row	Generic
5th row	Generic

Common Values

Value	Count	Frequency (%)
Generic	7285	70.6%
Determine	799	7.7%
Uni-Gold	373	3.6%
Aluvia	250	2.4%
Kaletra	165	1.6%
Norvir	136	1.3%
Stat-Pak	115	1.1%
Bioline	113	1.1%
Truvada	94	0.9%
Videx	84	0.8%
Other values (38)	910	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
generic	7285	69.7%
determine	799	7.6%
uni-gold	373	3.6%
aluvia	250	2.4%
kaletra	165	1.6%
norvir	136	1.3%
videx	125	1.2%
stat-pak	115	1.1%
bioline	113	1.1%
truvada	94	0.9%
Other values (40)	995	9.5%

Most occurring characters

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	63406	84.3%
Uppercase Letter	11151	14.8%
Dash Punctuation	489	0.6%
Space Separator	126	0.2%
Other Punctuation	69	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	18044	28.5%
i	10118	16.0%
r	9288	14.6%
n	8958	14.1%
c	7463	11.8%
t	1628	2.6%
a	1599	2.5%
l	1331	2.1%
o	991	1.6%
m	856	1.4%
Other values (13)	3130	4.9%

Uppercase Letter

Value	Count	Frequency (%)
G	7758	69.6%
D	804	7.2%
U	373	3.3%
A	271	2.4%
S	259	2.3%
C	227	2.0%
V	222	2.0%
K	167	1.5%
P	163	1.5%
N	141	1.3%
Other values (12)	766	6.9%

Dash Punctuation

Value	Count	Frequency (%)
-	489	100.0%

Space Separator

Value	Count	Frequency (%)
	126	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	69	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	74557	99.1%
Common	684	0.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	18044	24.2%
i	10118	13.6%
r	9288	12.5%
n	8958	12.0%
G	7758	10.4%
c	7463	10.0%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (35)	7379	9.9%

Common

Value	Count	Frequency (%)
-	489	71.5%
	126	18.4%
/	69	10.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	75241	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

dosage
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	54
Distinct (%)	0.6%
Missing	1736
Missing (%)	16.8%
Memory size	80.8 KiB

300mg	990
200mg	932
600mg	772
150/300mg	600
150/300/200mg	580
Other values (49)	4714

Length

Max length	15
Median length	13
Mean length	7.354448067
Min length	2

Characters and Unicode

Total characters	63160
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	10mg/ml
2nd row	150mg
3rd row	30mg
4th row	10mg/ml
5th row	200mg

Common Values

Value	Count	Frequency (%)
300mg	990	9.6%
200mg	932	9.0%
600mg	772	7.5%
150/300mg	600	5.8%
150/300/200mg	580	5.6%
10mg/ml	552	5.3%
150mg	431	4.2%
200/50mg	395	3.8%
300/300mg	301	2.9%
600/300/300mg	286	2.8%
Other values (44)	2749	26.6%
(Missing)	1736	16.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
300mg	990	11.5%
200mg	932	10.9%
600mg	772	9.0%
150/300mg	600	7.0%
150/300/200mg	580	6.8%
10mg/ml	552	6.4%
150mg	431	5.0%
200/50mg	395	4.6%
300/300mg	301	3.5%
600/300/300mg	286	3.3%
Other values (44)	2749	32.0%

Most occurring characters

Value	Count	Frequency (%)
0	21765	34.5%
m	9548	15.1%
g	8596	13.6%
/	6117	9.7%
3	4855	7.7%
2	3187	5.0%
1	3098	4.9%
5	3045	4.8%
6	1613	2.6%
l	964	1.5%
Other values (4)	372	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37901	60.0%
Lowercase Letter	19108	30.3%
Other Punctuation	6131	9.7%
Math Symbol	20	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	21765	57.4%
3	4855	12.8%
2	3187	8.4%
1	3098	8.2%
5	3045	8.0%
6	1613	4.3%
8	171	0.5%
4	167	0.4%

Lowercase Letter

Value	Count	Frequency (%)
m	9548	50.0%
g	8596	45.0%
l	964	5.0%

Other Punctuation

Value	Count	Frequency (%)
/	6117	99.8%
.	14	0.2%

Math Symbol

Value	Count	Frequency (%)
+	20	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	44052	69.7%
Latin	19108	30.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	21765	49.4%
/	6117	13.9%
3	4855	11.0%
2	3187	7.2%
1	3098	7.0%
5	3045	6.9%
6	1613	3.7%
8	171	0.4%
4	167	0.4%
+	20	< 0.1%

Latin

Value	Count	Frequency (%)
m	9548	50.0%
g	8596	45.0%
l	964	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	63160	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	21765	34.5%
m	9548	15.1%
g	8596	13.6%
/	6117	9.7%
3	4855	7.7%
2	3187	5.0%
1	3098	4.9%
5	3045	4.8%
6	1613	2.6%
l	964	1.5%
Other values (4)	372	0.6%

dosage form
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Tablet	3532
Tablet - FDC	2749
Test kit	1575
Capsule	729
Oral solution	727
Other values (12)	1012

Length

Max length	34
Median length	33
Mean length	10.25358388
Min length	6

Characters and Unicode

Total characters	105858
Distinct characters	32
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Test kit
2nd row	Oral suspension
3rd row	Test kit
4th row	Tablet
5th row	Capsule

Common Values

Value	Count	Frequency (%)
Tablet	3532	34.2%
Tablet - FDC	2749	26.6%
Test kit	1575	15.3%
Capsule	729	7.1%
Oral solution	727	7.0%
Chewable/dispersible tablet - FDC	239	2.3%
Oral suspension	214	2.1%
Test kit - Ancillary	161	1.6%
Chewable/dispersible tablet	146	1.4%
Delayed-release capsules	131	1.3%
Other values (7)	121	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tablet	6711	33.3%
	3270	16.2%
fdc	3023	15.0%
test	1736	8.6%
kit	1736	8.6%
oral	970	4.8%
solution	755	3.7%
capsule	729	3.6%
chewable/dispersible	385	1.9%
suspension	214	1.1%
Other values (8)	654	3.2%

Most occurring characters

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	72598	68.6%
Uppercase Letter	19554	18.5%
Space Separator	9859	9.3%
Dash Punctuation	3427	3.2%
Other Punctuation	385	0.4%
Math Symbol	35	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	12083	16.6%
t	11415	15.7%
l	10859	15.0%
a	9472	13.0%
b	7567	10.4%
s	5234	7.2%
i	3728	5.1%
u	1870	2.6%
o	1835	2.5%
r	1831	2.5%
Other values (10)	6704	9.2%

Uppercase Letter

Value	Count	Frequency (%)
T	8062	41.2%
C	4137	21.2%
D	3195	16.3%
F	3023	15.5%
O	942	4.8%
A	161	0.8%
P	28	0.1%
I	6	< 0.1%

Space Separator

Value	Count	Frequency (%)
	9859	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3427	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	385	100.0%

Math Symbol

Value	Count	Frequency (%)
+	35	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	92152	87.1%
Common	13706	12.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	12083	13.1%
t	11415	12.4%
l	10859	11.8%
a	9472	10.3%
T	8062	8.7%
b	7567	8.2%
s	5234	5.7%
C	4137	4.5%
i	3728	4.0%
D	3195	3.5%
Other values (18)	16400	17.8%

Common

Value	Count	Frequency (%)
	9859	71.9%
-	3427	25.0%
/	385	2.8%
+	35	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	105858	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

unit of measure (per pack)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.990895

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	30
median	60
Q3	90
95-th percentile	240
Maximum	1000
Range	999
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	76.57976396
Coefficient of variation (CV)	0.9819064643
Kurtosis	36.09399876
Mean	77.990895
Median Absolute Deviation (MAD)	30
Skewness	4.302502487
Sum	805178
Variance	5864.460248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
60	4121	39.9%
30	2630	25.5%
100	976	9.5%
240	670	6.5%
120	474	4.6%
20	470	4.6%
90	222	2.2%
300	157	1.5%
1	126	1.2%
25	114	1.1%
Other values (21)	364	3.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	126	1.2%
2	4	< 0.1%
3	8	0.1%
5	4	< 0.1%
12	2	< 0.1%
18	4	< 0.1%
20	470	4.6%
24	2	< 0.1%
25	114	1.1%
30	2630	25.5%

Value	Count	Frequency (%)
1000	16	0.2%
720	5	< 0.1%
540	7	0.1%
336	39	0.4%
300	157	1.5%
270	53	0.5%
240	670	6.5%
200	76	0.7%
180	76	0.7%
168	3	< 0.1%

line item quantity
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5065
Distinct (%)	49.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18332.53487

Minimum	1
Maximum	619999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	17
Q1	408
median	3000
Q3	17039.75
95-th percentile	90951.55
Maximum	619999
Range	619998
Interquartile range (IQR)	16631.75

Descriptive statistics

Standard deviation	40035.30296
Coefficient of variation (CV)	2.18383891
Kurtosis	40.0503001
Mean	18332.53487
Median Absolute Deviation (MAD)	2950
Skewness	5.038314699
Sum	189265090
Variance	1602825483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	93	0.9%
1000	91	0.9%
100	87	0.8%
2000	73	0.7%
5000	69	0.7%
500	67	0.6%
20000	67	0.6%
3000	66	0.6%
3	63	0.6%
50000	62	0.6%
Other values (5055)	9586	92.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	35	0.3%
2	40	0.4%
3	63	0.6%
4	46	0.4%
5	28	0.3%
6	48	0.5%
7	27	0.3%
8	26	0.3%
9	22	0.2%
10	54	0.5%

Value	Count	Frequency (%)
619999	1	< 0.1%
600906	1	< 0.1%
555197	1	< 0.1%
515000	3	< 0.1%
514526	1	< 0.1%
460041	1	< 0.1%
440000	1	< 0.1%
438409	1	< 0.1%
401961	1	< 0.1%
400000	2	< 0.1%

line item value
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8741
Distinct (%)	84.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	157650.5673

Minimum	0
Maximum	5951990.4
Zeros	17
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	192.5755
Q1	4314.5925
median	30471.465
Q3	166447.14
95-th percentile	702831
Maximum	5951990.4
Range	5951990.4
Interquartile range (IQR)	162132.5475

Descriptive statistics

Standard deviation	345292.067
Coefficient of variation (CV)	2.190236755
Kurtosis	54.15243042
Mean	157650.5673
Median Absolute Deviation (MAD)	29920.465
Skewness	5.837020186
Sum	1627584457
Variance	1.192266115 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200000	29	0.3%
16000	23	0.2%
800	18	0.2%
0	17	0.2%
14400	16	0.2%
3200	15	0.1%
244216	15	0.1%
120000	13	0.1%
160	11	0.1%
250	11	0.1%
Other values (8731)	10156	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17	0.2%
0.01	1	< 0.1%
0.03	1	< 0.1%
0.12	1	< 0.1%
0.2	1	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.42	1	< 0.1%
0.5	1	< 0.1%
0.7	1	< 0.1%

Value	Count	Frequency (%)
5951990.4	1	< 0.1%
5768697.6	1	< 0.1%
5329891.2	1	< 0.1%
5140114.74	1	< 0.1%
4959241.98	1	< 0.1%
4278871.84	1	< 0.1%
4228629.72	1	< 0.1%
4014000	1	< 0.1%
3932880	1	< 0.1%
3904000	2	< 0.1%

pack price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1175
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.91024119

Minimum	0
Maximum	1345.64
Zeros	18
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1.9
Q1	4.12
median	9.3
Q3	23.5925
95-th percentile	80
Maximum	1345.64
Range	1345.64
Interquartile range (IQR)	19.4725

Descriptive statistics

Standard deviation	45.60922308
Coefficient of variation (CV)	2.081639481
Kurtosis	293.1762044
Mean	21.91024119
Median Absolute Deviation (MAD)	6.57
Skewness	12.98843214
Sum	226201.33
Variance	2080.20123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	368	3.6%
80	307	3.0%
89	183	1.8%
11.22	139	1.3%
20	110	1.1%
1.95	91	0.9%
8.76	91	0.9%
2.44	90	0.9%
2.1	89	0.9%
2.26	88	0.9%
Other values (1165)	8768	84.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	0.2%
0.01	85	0.8%
0.39	2	< 0.1%
0.7	2	< 0.1%
0.9	4	< 0.1%
1.1	2	< 0.1%
1.14	2	< 0.1%
1.17	1	< 0.1%
1.2	1	< 0.1%
1.21	1	< 0.1%

Value	Count	Frequency (%)
1345.64	1	< 0.1%
1250	1	< 0.1%
1242.53	3	< 0.1%
750.29	1	< 0.1%
700	1	< 0.1%
400	9	0.1%
350	39	0.4%
308.17	3	< 0.1%
306.88	3	< 0.1%
301.53	1	< 0.1%

unit price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	183
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6117008911

Minimum	0
Maximum	238.65
Zeros	103
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.01
Q1	0.08
median	0.16
Q3	0.47
95-th percentile	1.6
Maximum	238.65
Range	238.65
Interquartile range (IQR)	0.39

Descriptive statistics

Standard deviation	3.275807741
Coefficient of variation (CV)	5.35524435
Kurtosis	2725.960252
Mean	0.6117008911
Median Absolute Deviation (MAD)	0.12
Skewness	40.58484939
Sum	6315.2
Variance	10.73091635
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.04	713	6.9%
0.01	492	4.8%
0.12	464	4.5%
0.14	444	4.3%
0.8	411	4.0%
0.11	400	3.9%
1.6	368	3.6%
0.05	343	3.3%
0.16	343	3.3%
0.19	321	3.1%
Other values (173)	6025	58.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	103	1.0%
0.01	492	4.8%
0.02	140	1.4%
0.03	250	2.4%
0.04	713	6.9%
0.05	343	3.3%
0.06	274	2.7%
0.07	248	2.4%
0.08	146	1.4%
0.09	154	1.5%

Value	Count	Frequency (%)
238.65	1	< 0.1%
41.68	1	< 0.1%
37.5	2	< 0.1%
30	1	< 0.1%
26.91	1	< 0.1%
25	4	< 0.1%
24.85	3	< 0.1%
24.5	46	0.4%
23	23	0.2%
17.12	3	< 0.1%

manufacturing site
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	88
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Aurobindo Unit III, India	3172
Mylan (formerly Matrix) Nashik	1415
Hetero Unit III Hyderabad IN	869
Cipla, Goa, India	665
Strides, Bangalore, India.	540
Other values (83)	3663

Length

Max length	72
Median length	37
Mean length	25.03913212
Min length	5

Characters and Unicode

Total characters	258504
Distinct characters	69
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	0.2%

Sample

1st row	Ranbaxy Fine Chemicals LTD
2nd row	Aurobindo Unit III, India
3rd row	ABBVIE GmbH & Co.KG Wiesbaden
4th row	Ranbaxy, Paonta Shahib, India
5th row	Aurobindo Unit III, India

Common Values

Value	Count	Frequency (%)
Aurobindo Unit III, India	3172	30.7%
Mylan (formerly Matrix) Nashik	1415	13.7%
Hetero Unit III Hyderabad IN	869	8.4%
Cipla, Goa, India	665	6.4%
Strides, Bangalore, India.	540	5.2%
Alere Medical Co., Ltd.	481	4.7%
Trinity Biotech, Plc	405	3.9%
ABBVIE Ludwigshafen Germany	366	3.5%
Inverness Japan	345	3.3%
ABBVIE (Abbott) Logis. UK	219	2.1%
Other values (78)	1847	17.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
india	4678	11.9%
unit	4197	10.7%
iii	4041	10.3%
aurobindo	3283	8.4%
mylan	1438	3.7%
formerly	1415	3.6%
matrix	1415	3.6%
nashik	1415	3.6%
in	1047	2.7%
hetero	913	2.3%
Other values (201)	15396	39.2%

Most occurring characters

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	160634	62.1%
Uppercase Letter	53461	20.7%
Space Separator	28937	11.2%
Other Punctuation	11140	4.3%
Close Punctuation	1827	0.7%
Open Punctuation	1827	0.7%
Dash Punctuation	435	0.2%
Decimal Number	242	0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	20789	12.9%
a	18921	11.8%
n	18236	11.4%
r	13636	8.5%
o	12958	8.1%
d	12314	7.7%
e	10570	6.6%
t	10195	6.3%
l	6416	4.0%
b	5385	3.4%
Other values (16)	31214	19.4%

Uppercase Letter

Value	Count	Frequency (%)
I	19607	36.7%
A	5146	9.6%
U	4492	8.4%
M	4127	7.7%
B	2746	5.1%
N	2729	5.1%
H	2130	4.0%
S	1830	3.4%
C	1732	3.2%
G	1371	2.6%
Other values (14)	7551	14.1%

Decimal Number

Value	Count	Frequency (%)
2	96	39.7%
1	54	22.3%
5	44	18.2%
3	26	10.7%
4	17	7.0%
7	2	0.8%
6	1	0.4%
9	1	0.4%
0	1	0.4%

Other Punctuation

Value	Count	Frequency (%)
,	8728	78.3%
.	2314	20.8%
&	66	0.6%
'	28	0.3%
/	4	< 0.1%

Space Separator

Value	Count	Frequency (%)
	28937	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1827	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1827	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	435	100.0%

Modifier Symbol

Value	Count	Frequency (%)
¸	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	214095	82.8%
Common	44409	17.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	20789	9.7%
I	19607	9.2%
a	18921	8.8%
n	18236	8.5%
r	13636	6.4%
o	12958	6.1%
d	12314	5.8%
e	10570	4.9%
t	10195	4.8%
l	6416	3.0%
Other values (40)	70453	32.9%

Common

Value	Count	Frequency (%)
	28937	65.2%
,	8728	19.7%
.	2314	5.2%
)	1827	4.1%
(	1827	4.1%
-	435	1.0%
2	96	0.2%
&	66	0.1%
1	54	0.1%
5	44	0.1%
Other values (9)	81	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	258502	> 99.9%
Latin 1 Sup	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (57)	92339	35.7%

Latin 1 Sup

Value	Count	Frequency (%)
Ã	1	50.0%
¸	1	50.0%

first line designation
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.2 KiB

True	7030
False	3294

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	7030	68.1%
False	3294	31.9%

weight (kilograms)
Categorical

HIGH CARDINALITY

Distinct	4688
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Weight Captured Separately	1507
2	29
6	26
1	23
5	20
Other values (4683)	8719

Length

Max length	26
Median length	24
Mean length	11.35916312
Min length	1

Characters and Unicode

Total characters	117272
Distinct characters	35
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3014 ?
Unique (%)	29.2%

Sample

1st row	13
2nd row	358
3rd row	171
4th row	1855
5th row	7590

Common Values

Value	Count	Frequency (%)
Weight Captured Separately	1507	14.6%
2	29	0.3%
6	26	0.3%
1	23	0.2%
5	20	0.2%
60	20	0.2%
4	19	0.2%
3	18	0.2%
39	17	0.2%
9	17	0.2%
Other values (4678)	8628	83.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
see	2445	13.4%
weight	1507	8.3%
separately	1507	8.3%
captured	1507	8.3%
2	29	0.2%
6	26	0.1%
1	23	0.1%
5	20	0.1%
60	20	0.1%
4	19	0.1%
Other values (5980)	11125	61.0%

Most occurring characters

Value	Count	Frequency (%)
e	10918	9.3%
	7904	6.7%
1	6455	5.5%
2	5833	5.0%
3	5113	4.4%
8	4534	3.9%
t	4521	3.9%
a	4521	3.9%
S	4460	3.8%
D	4382	3.7%
Other values (25)	58631	50.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	43352	37.0%
Lowercase Letter	36537	31.2%
Uppercase Letter	17254	14.7%
Space Separator	7904	6.7%
Other Punctuation	4890	4.2%
Open Punctuation	2445	2.1%
Close Punctuation	2445	2.1%
Dash Punctuation	2445	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10918	29.9%
t	4521	12.4%
a	4521	12.4%
r	3014	8.2%
p	3014	8.2%
y	1507	4.1%
l	1507	4.1%
d	1507	4.1%
u	1507	4.1%
h	1507	4.1%
Other values (2)	3014	8.2%

Decimal Number

Value	Count	Frequency (%)
1	6455	14.9%
2	5833	13.5%
3	5113	11.8%
8	4534	10.5%
4	4073	9.4%
5	3786	8.7%
0	3559	8.2%
6	3541	8.2%
7	3309	7.6%
9	3149	7.3%

Uppercase Letter

Value	Count	Frequency (%)
S	4460	25.8%
D	4382	25.4%
N	2445	14.2%
I	2445	14.2%
W	1507	8.7%
C	1507	8.7%
A	508	2.9%

Other Punctuation

Value	Count	Frequency (%)
#	2445	50.0%
:	2445	50.0%

Space Separator

Value	Count	Frequency (%)
	7904	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2445	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2445	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2445	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	63481	54.1%
Latin	53791	45.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10918	20.3%
t	4521	8.4%
a	4521	8.4%
S	4460	8.3%
D	4382	8.1%
r	3014	5.6%
p	3014	5.6%
N	2445	4.5%
I	2445	4.5%
W	1507	2.8%
Other values (9)	12564	23.4%

Common

Value	Count	Frequency (%)
	7904	12.5%
1	6455	10.2%
2	5833	9.2%
3	5113	8.1%
8	4534	7.1%
4	4073	6.4%
5	3786	6.0%
0	3559	5.6%
6	3541	5.6%
7	3309	5.2%
Other values (6)	15374	24.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117272	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	10918	9.3%
	7904	6.7%
1	6455	5.5%
2	5833	5.0%
3	5113	4.4%
8	4534	3.9%
t	4521	3.9%
a	4521	3.9%
S	4460	3.8%
D	4382	3.7%
Other values (25)	58631	50.0%

freight cost (usd)
Categorical

HIGH CARDINALITY

Distinct	6733
Distinct (%)	65.2%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Freight Included in Commodity Cost	1442
Invoiced Separately	239
9736.1	36
6147.18	27
See DN-304 (ID#:10589)	16
Other values (6728)	8564

Length

Max length	34
Median length	24
Mean length	14.79523441
Min length	2

Characters and Unicode

Total characters	152746
Distinct characters	42
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5849 ?
Unique (%)	56.7%

Sample

1st row	780.34
2nd row	4521.5
3rd row	1653.78
4th row	16007.06
5th row	45450.08

Common Values

Value	Count	Frequency (%)
Freight Included in Commodity Cost	1442	14.0%
Invoiced Separately	239	2.3%
9736.1	36	0.3%
6147.18	27	0.3%
See DN-304 (ID#:10589)	16	0.2%
7445.8	16	0.2%
13398.06	16	0.2%
9341.49	15	0.1%
See ASN-32231 (ID#:13648)	14	0.1%
See ASN-31750 (ID#:19272)	14	0.1%
Other values (6723)	8489	82.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
see	2445	11.5%
freight	1442	6.8%
in	1442	6.8%
commodity	1442	6.8%
cost	1442	6.8%
included	1442	6.8%
invoiced	239	1.1%
separately	239	1.1%
9736.1	36	0.2%
6147.18	27	0.1%
Other values (8028)	11025	52.0%

Most occurring characters

Value	Count	Frequency (%)
	10897	7.1%
e	8491	5.6%
1	8391	5.5%
2	7344	4.8%
3	6673	4.4%
8	6162	4.0%
.	5734	3.8%
4	5646	3.7%
5	5346	3.5%
6	5136	3.4%
Other values (32)	82926	54.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	58705	38.4%
Lowercase Letter	46206	30.3%
Uppercase Letter	18979	12.4%
Space Separator	10897	7.1%
Other Punctuation	10624	7.0%
Open Punctuation	2445	1.6%
Dash Punctuation	2445	1.6%
Close Punctuation	2445	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	8491	18.4%
t	4565	9.9%
d	4565	9.9%
o	4565	9.9%
i	4565	9.9%
n	3123	6.8%
m	2884	6.2%
r	1681	3.6%
y	1681	3.6%
l	1681	3.6%
Other values (8)	8405	18.2%

Decimal Number

Value	Count	Frequency (%)
1	8391	14.3%
2	7344	12.5%
3	6673	11.4%
8	6162	10.5%
4	5646	9.6%
5	5346	9.1%
6	5136	8.7%
9	4752	8.1%
7	4746	8.1%
0	4509	7.7%

Uppercase Letter

Value	Count	Frequency (%)
D	4382	23.1%
I	4126	21.7%
S	3192	16.8%
C	2884	15.2%
N	2445	12.9%
F	1442	7.6%
A	508	2.7%

Other Punctuation

Value	Count	Frequency (%)
.	5734	54.0%
#	2445	23.0%
:	2445	23.0%

Space Separator

Value	Count	Frequency (%)
	10897	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2445	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2445	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2445	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	87561	57.3%
Latin	65185	42.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8491	13.0%
t	4565	7.0%
d	4565	7.0%
o	4565	7.0%
i	4565	7.0%
D	4382	6.7%
I	4126	6.3%
S	3192	4.9%
n	3123	4.8%
m	2884	4.4%
Other values (15)	20727	31.8%

Common

Value	Count	Frequency (%)
	10897	12.4%
1	8391	9.6%
2	7344	8.4%
3	6673	7.6%
8	6162	7.0%
.	5734	6.5%
4	5646	6.4%
5	5346	6.1%
6	5136	5.9%
9	4752	5.4%
Other values (7)	21480	24.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	152746	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	10897	7.1%
e	8491	5.6%
1	8391	5.5%
2	7344	4.8%
3	6673	4.4%
8	6162	4.0%
.	5734	3.8%
4	5646	3.7%
5	5346	3.5%
6	5136	3.4%
Other values (32)	82926	54.3%

line item insurance (usd)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	6722
Distinct (%)	67.0%
Missing	287
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	240.1176258

Minimum	0
Maximum	7708.44
Zeros	54
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.25
Q1	6.51
median	47.04
Q3	252.4
95-th percentile	1082.032
Maximum	7708.44
Range	7708.44
Interquartile range (IQR)	245.89

Descriptive statistics

Standard deviation	500.1905677
Coefficient of variation (CV)	2.083106419
Kurtosis	34.91121486
Mean	240.1176258
Median Absolute Deviation (MAD)	46.27
Skewness	4.827162374
Sum	2410060.61
Variance	250190.604
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	54	0.5%
0.02	37	0.4%
0.07	33	0.3%
0.05	30	0.3%
0.06	30	0.3%
0.01	26	0.3%
0.03	23	0.2%
0.09	21	0.2%
0.08	20	0.2%
0.49	18	0.2%
Other values (6712)	9745	94.4%
(Missing)	287	2.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	54	0.5%
0.01	26	0.3%
0.02	37	0.4%
0.03	23	0.2%
0.04	14	0.1%
0.05	30	0.3%
0.06	30	0.3%
0.07	33	0.3%
0.08	20	0.2%
0.09	21	0.2%

Value	Count	Frequency (%)
7708.44	1	< 0.1%
7005.49	1	< 0.1%
5930.22	1	< 0.1%
5573.31	1	< 0.1%
5479.13	1	< 0.1%
5284.04	1	< 0.1%
5230.81	1	< 0.1%
5162.29	1	< 0.1%
5145	2	< 0.1%
5098.1	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	project code	pq #	po / so #	asn/dn #	country	managed by	fulfill via	vendor inco term	shipment mode	pq first sent to client date	po sent to vendor date	scheduled delivery date	delivered to client date	delivery recorded date	product group	sub classification	vendor	item description	molecule/test type	brand	dosage	dosage form	unit of measure (per pack)	line item quantity	line item value	pack price	unit price	manufacturing site	first line designation	weight (kilograms)	freight cost (usd)	line item insurance (usd)
0	1	100-CI-T01	Pre-PQ Process	SCMS-4	ASN-8	Côte d'Ivoire	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	2-Jun-06	2-Jun-06	2-Jun-06	HRDT	HIV test	RANBAXY Fine Chemicals LTD.	HIV, Reveal G3 Rapid HIV-1 Antibody Test, 30 Tests	HIV, Reveal G3 Rapid HIV-1 Antibody Test	Reveal	NaN	Test kit	30	19	551.00	29.00	0.97	Ranbaxy Fine Chemicals LTD	True	13	780.34	NaN
1	3	108-VN-T01	Pre-PQ Process	SCMS-13	ASN-85	Vietnam	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	14-Nov-06	14-Nov-06	14-Nov-06	ARV	Pediatric	Aurobindo Pharma Limited	Nevirapine 10mg/ml, oral suspension, Bottle, 240 ml	Nevirapine	Generic	10mg/ml	Oral suspension	240	1000	6200.00	6.20	0.03	Aurobindo Unit III, India	True	358	4521.5	NaN
2	4	100-CI-T01	Pre-PQ Process	SCMS-20	ASN-14	Côte d'Ivoire	PMO - US	Direct Drop	FCA	Air	Pre-PQ Process	Date Not Captured	27-Aug-06	27-Aug-06	27-Aug-06	HRDT	HIV test	Abbott GmbH & Co. KG	HIV 1/2, Determine Complete HIV Kit, 100 Tests	HIV 1/2, Determine Complete HIV Kit	Determine	NaN	Test kit	100	500	40000.00	80.00	0.80	ABBVIE GmbH & Co.KG Wiesbaden	True	171	1653.78	NaN
3	15	108-VN-T01	Pre-PQ Process	SCMS-78	ASN-50	Vietnam	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	1-Sep-06	1-Sep-06	1-Sep-06	ARV	Adult	SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED)	Lamivudine 150mg, tablets, 60 Tabs	Lamivudine	Generic	150mg	Tablet	60	31920	127360.80	3.99	0.07	Ranbaxy, Paonta Shahib, India	True	1855	16007.06	NaN
4	16	108-VN-T01	Pre-PQ Process	SCMS-81	ASN-55	Vietnam	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	11-Aug-06	11-Aug-06	11-Aug-06	ARV	Adult	Aurobindo Pharma Limited	Stavudine 30mg, capsules, 60 Caps	Stavudine	Generic	30mg	Capsule	60	38000	121600.00	3.20	0.05	Aurobindo Unit III, India	True	7590	45450.08	NaN
5	23	112-NG-T01	Pre-PQ Process	SCMS-87	ASN-57	Nigeria	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	28-Sep-06	28-Sep-06	28-Sep-06	ARV	Pediatric	Aurobindo Pharma Limited	Zidovudine 10mg/ml, oral solution, Bottle, 240 ml	Zidovudine	Generic	10mg/ml	Oral solution	240	416	2225.60	5.35	0.02	Aurobindo Unit III, India	True	504	5920.42	NaN
6	44	110-ZM-T01	Pre-PQ Process	SCMS-139	ASN-130	Zambia	PMO - US	Direct Drop	DDU	Air	Pre-PQ Process	Date Not Captured	8-Jan-07	8-Jan-07	8-Jan-07	ARV	Pediatric	MERCK SHARP & DOHME IDEA GMBH (FORMALLY MERCK SHARP & DOHME B.V.)	Efavirenz 200mg [Stocrin/Sustiva], capsule, 90 Caps	Efavirenz	Stocrin/Sustiva	200mg	Capsule	90	135	4374.00	32.40	0.36	MSD South Granville Australia	True	328	Freight Included in Commodity Cost	NaN
7	45	109-TZ-T01	Pre-PQ Process	SCMS-140	ASN-94	Tanzania	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	24-Nov-06	24-Nov-06	24-Nov-06	ARV	Adult	Aurobindo Pharma Limited	Nevirapine 200mg, tablets, 60 Tabs	Nevirapine	Generic	200mg	Tablet	60	16667	60834.55	3.65	0.06	Aurobindo Unit III, India	True	1478	6212.41	NaN
8	46	112-NG-T01	Pre-PQ Process	SCMS-156	ASN-93	Nigeria	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	7-Dec-06	7-Dec-06	7-Dec-06	ARV	Adult	Aurobindo Pharma Limited	Stavudine 30mg, capsules, 60 Caps	Stavudine	Generic	30mg	Capsule	60	273	532.35	1.95	0.03	Aurobindo Unit III, India	False	See ASN-93 (ID#:1281)	See ASN-93 (ID#:1281)	NaN
9	47	110-ZM-T01	Pre-PQ Process	SCMS-165	ASN-199	Zambia	PMO - US	Direct Drop	CIP	Air	Pre-PQ Process	11/13/2006	30-Jan-07	30-Jan-07	30-Jan-07	ARV	Adult	ABBVIE LOGISTICS (FORMERLY ABBOTT LOGISTICS BV)	Lopinavir/Ritonavir 200/50mg [Aluvia], tablets, 120 Tabs	Lopinavir/Ritonavir	Aluvia	200/50mg	Tablet	120	2800	115080.00	41.10	0.34	ABBVIE (Abbott) St. P'burg USA	True	643	Freight Included in Commodity Cost	NaN

Last rows

	id	project code	pq #	po / so #	asn/dn #	country	managed by	fulfill via	vendor inco term	shipment mode	pq first sent to client date	po sent to vendor date	scheduled delivery date	delivered to client date	delivery recorded date	product group	sub classification	vendor	item description	molecule/test type	brand	dosage	dosage form	unit of measure (per pack)	line item quantity	line item value	pack price	unit price	manufacturing site	first line designation	weight (kilograms)	freight cost (usd)	line item insurance (usd)
10314	86813	151-NG-T30	FPQ-14989	SO-51422	DN-4274	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	9/19/2014	N/A - From RDC	30-Jun-15	15-May-15	22-May-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs	Lamivudine/Nevirapine/Zidovudine	Generic	30/50/60mg	Chewable/dispersible tablet - FDC	60	10340	37224.00	3.60	0.06	Mylan (formerly Matrix) Nashik	False	See DN-4274 (ID#:84472)	See DN-4274 (ID#:84472)	38.27
10315	86814	151-NG-T30	FPQ-14989	SO-51424	DN-4276	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	9/19/2014	N/A - From RDC	30-Jun-15	15-May-15	22-May-15	ARV	Adult	SCMS from RDC	Lopinavir/Ritonavir 200/50mg [Aluvia], tablets, 120 Tabs	Lopinavir/Ritonavir	Aluvia	200/50mg	Tablet	120	70000	1304800.00	18.64	0.16	ABBVIE Ludwigshafen Germany	True	15198	26180	1341.33
10316	86815	151-NG-T30	FPQ-16313	SO-51420	DN-4279	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	5/4/2015	N/A - From RDC	2-Jun-15	15-May-15	22-May-15	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	150/300mg	Tablet - FDC	60	15000	97800.00	6.52	0.11	Aurobindo Unit III, India	True	1547	3410	115.11
10317	86816	151-NG-T30	FPQ-16313	SO-51440	DN-4282	Nigeria	PMO - US	From RDC	N/A - From RDC	Air	5/4/2015	N/A - From RDC	30-Jun-15	22-Jun-15	29-Jun-15	ARV	Adult	SCMS from RDC	Efavirenz 600mg, tablets, 30 Tabs	Efavirenz	Generic	600mg	Tablet	30	6724	20978.88	3.12	0.10	Strides, Bangalore, India.	False	See DN-4282 (ID#:83919)	See DN-4282 (ID#:83919)	24.69
10318	86817	103-ZW-T30	FPQ-15197	SO-50020	DN-4307	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	10/16/2014	N/A - From RDC	31-Jul-15	15-Jul-15	20-Jul-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs	Lamivudine/Nevirapine/Zidovudine	Generic	30/50/60mg	Chewable/dispersible tablet - FDC	60	205243	738874.80	3.60	0.06	Cipla, Goa, India	False	See DN-4307 (ID#:83920)	See DN-4307 (ID#:83920)	869.66
10319	86818	103-ZW-T30	FPQ-15197	SO-50020	DN-4307	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	10/16/2014	N/A - From RDC	31-Jul-15	15-Jul-15	20-Jul-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs	Lamivudine/Nevirapine/Zidovudine	Generic	30/50/60mg	Chewable/dispersible tablet - FDC	60	166571	599655.60	3.60	0.06	Mylan, H-12 & H-13, India	False	See DN-4307 (ID#:83920)	See DN-4307 (ID#:83920)	705.79
10320	86819	104-CI-T30	FPQ-15259	SO-50102	DN-4313	Côte d'Ivoire	PMO - US	From RDC	N/A - From RDC	Truck	10/24/2014	N/A - From RDC	31-Jul-15	6-Aug-15	7-Aug-15	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	150/300mg	Tablet - FDC	60	21072	137389.44	6.52	0.11	Hetero Unit III Hyderabad IN	False	See DN-4313 (ID#:83921)	See DN-4313 (ID#:83921)	161.71
10321	86821	110-ZM-T30	FPQ-14784	SO-49600	DN-4316	Zambia	PMO - US	From RDC	N/A - From RDC	Truck	8/12/2014	N/A - From RDC	31-Aug-15	25-Aug-15	3-Sep-15	ARV	Adult	SCMS from RDC	Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate 600/300/300mg, tablets, 30 Tabs	Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate	Generic	600/300/300mg	Tablet - FDC	30	514526	5140114.74	9.99	0.33	Cipla Ltd A-42 MIDC Mahar. IN	False	Weight Captured Separately	Freight Included in Commodity Cost	5284.04
10322	86822	200-ZW-T30	FPQ-16523	SO-51680	DN-4334	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	7/1/2015	N/A - From RDC	9-Sep-15	4-Aug-15	11-Aug-15	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	150/300mg	Tablet - FDC	60	17465	113871.80	6.52	0.11	Mylan (formerly Matrix) Nashik	True	1392	Freight Included in Commodity Cost	134.03
10323	86823	103-ZW-T30	FPQ-15197	SO-50022	DN-4336	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	10/16/2014	N/A - From RDC	31-Aug-15	4-Aug-15	11-Aug-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Zidovudine 30/60mg, dispersible tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	30/60mg	Chewable/dispersible tablet - FDC	60	36639	72911.61	1.99	0.03	Cipla, Goa, India	False	Weight Captured Separately	Freight Included in Commodity Cost	85.82

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Uppercase Letter

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII